Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

Precisa de iniciar sessão para iniciar uma discussão.

Termos relacionados

Siri
Software; CRM applications

Siri (speech interpretation and recognition interface) is ...

defragmentation
Software; Software engineering

In the maintenance of file systems, defragmentation is a ...

Spartan
Software; Web browser

Spartan is the new Microsoft web browser. The new ...

Nike+ Running App
Software; Phone apps

This app will help you to track your runs and reach new ...

Appsfire
Software; Phone apps

Appsfire offers free and highly discounted apps every ...

wiki
Software; Software development

With its origins in the Hawaiian word for “quick”, Wiki ...

Autor

Featured blossaries

General

Categoria: Politics   1 13 Terms

French Cuisine

Categoria: Food   2 20 Terms

Mars

Categoria: Cinência   2 5 Terms

Hiking Trip

Categoria: Desportos   1 6 Terms

Heathrow Restaurants and Lounges

Categoria: Viagem   2 5 Terms

Hotel management Terms

Categoria: Business   1 2 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Siga-nos em: